Data Warehouse Schema Evolution and Adaptation Framework Using Ontology
نویسنده
چکیده
Data Warehouse systems aim at integrating data from multiple heterogeneous, distributed, autonomous data sources. Due to changing business needs the data warehouse systems are never meant to be static. Changes in the data source structure or business requirements would result in the evolution of data warehouse schema structure. When data warehouse schema evolves the dependent modules such as its mappings, queries and views gets affected. The existing works on data warehouse evolution focus only on schema evolution at the physical level. As ontology seems to be a promising solution in data warehouse research, the proposed framework handles data warehouse schema evolution at ontological level. Moreover, it analyses the impact of the dependent modules and proposes methods to automatically adapt to changes. Keywords-Datawarehouse schema evolution; Multidimensional schema evolution,;Impact of data warehouse evolution
منابع مشابه
An Ontological Approach to Handle Multidimensional Schema Evolution for Data Warehouse
In recent years, the number of digital information storage and retrieval systems has increased immensely. Data warehousing has been found to be an extremely useful technology for integrating such heterogeneous and autonomous information sources. Data within the data warehouse is modelled in the form of a star or snowflake schema which facilitates business analysis in a multidimensional perspect...
متن کاملAn Ontology based Hybrid Approach to Derive Multidimensional Schema for Data Warehouse
Due to the diversity of data source data integration has become a challenging task. Data warehouse system plays a vital role to integrate the data for making important business decisions. Data within the data warehouse is arranged as multidimensional schema. In past many works exist to carry out the design of the multidimensional schema for data warehouse from either requirements and/or data so...
متن کاملAutomatic Generation of Warehouse Mediators Using an Ontology Engine
Data warehouses created for dynamic scientific environments, such as genetics, face significant challenges to their long-term feasibility. One of the most significant of these is the high frequency of schema evolution resulting from both technological advances and scientific insight. Failure to quickly incorporate these modifications will quickly render the warehouse obsolete, yet each evolutio...
متن کاملData Warehouse Evolution Framework
In this paper a data warehouse framework that supports data warehouse evolution is presented. The framework is able to handle not only changes in data sources, but also direct changes in a data warehouse schema. In the framework the data warehouse versions are supported in the development environment as well as in reports in the user environment.
متن کاملAn Improved Semantic Schema Matching Approach
Schema matching is a critical step in many applications, such as data warehouse loading, Online Analytical Process (OLAP), Data mining, semantic web [2] and schema integration. This task is defined for finding the semantic correspondences between elements of two schemas. Recently, schema matching has found considerable interest in both research and practice. In this paper, we present a new impr...
متن کامل